{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from IPython.core.interactiveshell import InteractiveShell\n",
    "InteractiveShell.ast_node_interactivity = \"all\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "emaotai = pd.read_csv(r'data/emaotai.csv')\n",
    "emaotai['时间'] = emaotai['时间'].str[:10]\n",
    "emaotai['销售额'] = emaotai['价格']*emaotai['已售出量']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "emaotai_0808 = emaotai[emaotai['时间']== '2017-08-08']\n",
    "emaotai_0816 = emaotai[emaotai['时间']== '2017-08-16']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "maotai_price_0816 = emaotai_0816.sort_values(by='价格', ascending=False)\n",
    "maotai_sales_count_0816 = emaotai_0816.sort_values(by='已售出量', ascending=False)\n",
    "maotai_sales_income_0816 = emaotai_0816.sort_values(by='销售额', ascending=False)\n",
    "maotai_view_count_0816 = emaotai_0816.sort_values(by='浏览量', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "maotai_price_0808 = emaotai_0808.sort_values(by='价格', ascending=False)\n",
    "maotai_sales_count_0808 = emaotai_0808.sort_values(by='已售出量', ascending=False)\n",
    "maotai_sales_income_0808 = emaotai_0808.sort_values(by='销售额', ascending=False)\n",
    "maotai_view_count_0808 = emaotai_0808.sort_values(by='浏览量', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>商品编号</th>\n",
       "      <th>价格</th>\n",
       "      <th>浏览量</th>\n",
       "      <th>已售出量</th>\n",
       "      <th>销售额</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>8.000000e+01</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>8.000000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>740.587500</td>\n",
       "      <td>3373.825000</td>\n",
       "      <td>2.030135e+05</td>\n",
       "      <td>4200.975000</td>\n",
       "      <td>8.624368e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>535.597116</td>\n",
       "      <td>6654.721226</td>\n",
       "      <td>5.810743e+05</td>\n",
       "      <td>16420.465533</td>\n",
       "      <td>2.478796e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>99.000000</td>\n",
       "      <td>3.087200e+04</td>\n",
       "      <td>76.000000</td>\n",
       "      <td>4.502400e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>275.000000</td>\n",
       "      <td>365.500000</td>\n",
       "      <td>5.826850e+04</td>\n",
       "      <td>629.500000</td>\n",
       "      <td>5.543865e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>794.500000</td>\n",
       "      <td>1599.000000</td>\n",
       "      <td>8.048750e+04</td>\n",
       "      <td>1552.000000</td>\n",
       "      <td>1.886100e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>1224.000000</td>\n",
       "      <td>2999.000000</td>\n",
       "      <td>1.373168e+05</td>\n",
       "      <td>2263.750000</td>\n",
       "      <td>8.939997e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1618.000000</td>\n",
       "      <td>39999.000000</td>\n",
       "      <td>4.500116e+06</td>\n",
       "      <td>142409.000000</td>\n",
       "      <td>1.849893e+08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              商品编号            价格           浏览量           已售出量           销售额\n",
       "count    80.000000     80.000000  8.000000e+01      80.000000  8.000000e+01\n",
       "mean    740.587500   3373.825000  2.030135e+05    4200.975000  8.624368e+06\n",
       "std     535.597116   6654.721226  5.810743e+05   16420.465533  2.478796e+07\n",
       "min       2.000000     99.000000  3.087200e+04      76.000000  4.502400e+04\n",
       "25%     275.000000    365.500000  5.826850e+04     629.500000  5.543865e+05\n",
       "50%     794.500000   1599.000000  8.048750e+04    1552.000000  1.886100e+06\n",
       "75%    1224.000000   2999.000000  1.373168e+05    2263.750000  8.939997e+06\n",
       "max    1618.000000  39999.000000  4.500116e+06  142409.000000  1.849893e+08"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "maotai_price_0816.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>时间</th>\n",
       "      <th>商品名</th>\n",
       "      <th>商品编号</th>\n",
       "      <th>品牌</th>\n",
       "      <th>价格</th>\n",
       "      <th>浏览量</th>\n",
       "      <th>已售出量</th>\n",
       "      <th>库存量</th>\n",
       "      <th>销售额</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>53度2.5L五星茅台酒 （乙未羊年）（按农历生肖属相推出）</td>\n",
       "      <td>1252</td>\n",
       "      <td>生肖纪念酒</td>\n",
       "      <td>39999.0</td>\n",
       "      <td>111619</td>\n",
       "      <td>76</td>\n",
       "      <td>0</td>\n",
       "      <td>3039924.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 甲午马年贵州茅台酒 五星53度2.5L（按农历生肖属相推出）</td>\n",
       "      <td>1251</td>\n",
       "      <td>生肖纪念酒</td>\n",
       "      <td>39999.0</td>\n",
       "      <td>118116</td>\n",
       "      <td>119</td>\n",
       "      <td>0</td>\n",
       "      <td>4759881.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 50年 53度500ml</td>\n",
       "      <td>17</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>18999.0</td>\n",
       "      <td>94591</td>\n",
       "      <td>1437</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>27301563.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 30年 53度500ml</td>\n",
       "      <td>18</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>11099.0</td>\n",
       "      <td>85641</td>\n",
       "      <td>1421</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>15771679.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 五星53度500ml(2000年)</td>\n",
       "      <td>289</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>7999.0</td>\n",
       "      <td>77894</td>\n",
       "      <td>1665</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>13318335.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 飞天53度500ml(2000年)</td>\n",
       "      <td>293</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>7999.0</td>\n",
       "      <td>63697</td>\n",
       "      <td>1560</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>12478440.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒新飞天茅台53度500ml（6瓶整箱购买）茅台官方商城正品直供</td>\n",
       "      <td>1044</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>7794.0</td>\n",
       "      <td>478854</td>\n",
       "      <td>14175</td>\n",
       "      <td>仅供展示</td>\n",
       "      <td>110479950.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 飞天53度500ml(2001年)</td>\n",
       "      <td>294</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>7499.0</td>\n",
       "      <td>39405</td>\n",
       "      <td>1604</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>12028396.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 飞天53度500ml(2002年)</td>\n",
       "      <td>295</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>6899.0</td>\n",
       "      <td>45043</td>\n",
       "      <td>1607</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>11086693.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 飞天53度500ml(2003年)</td>\n",
       "      <td>296</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>6599.0</td>\n",
       "      <td>43369</td>\n",
       "      <td>1572</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>10373628.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             时间                                    商品名  商品编号     品牌       价格  \\\n",
       "82   2017-08-16         53度2.5L五星茅台酒 （乙未羊年）（按农历生肖属相推出）  1252  生肖纪念酒  39999.0   \n",
       "128  2017-08-16     茅台酒 甲午马年贵州茅台酒 五星53度2.5L（按农历生肖属相推出）  1251  生肖纪念酒  39999.0   \n",
       "120  2017-08-16                     贵州茅台酒 50年 53度500ml    17  贵州茅台酒  18999.0   \n",
       "147  2017-08-16                     贵州茅台酒 30年 53度500ml    18  贵州茅台酒  11099.0   \n",
       "106  2017-08-16                  茅台酒 五星53度500ml(2000年)   289  贵州茅台酒   7999.0   \n",
       "125  2017-08-16                  茅台酒 飞天53度500ml(2000年)   293  贵州茅台酒   7999.0   \n",
       "148  2017-08-16   贵州茅台酒新飞天茅台53度500ml（6瓶整箱购买）茅台官方商城正品直供  1044  贵州茅台酒   7794.0   \n",
       "110  2017-08-16                  茅台酒 飞天53度500ml(2001年)   294  贵州茅台酒   7499.0   \n",
       "134  2017-08-16                  茅台酒 飞天53度500ml(2002年)   295  贵州茅台酒   6899.0   \n",
       "136  2017-08-16                  茅台酒 飞天53度500ml(2003年)   296  贵州茅台酒   6599.0   \n",
       "\n",
       "        浏览量   已售出量   库存量          销售额  \n",
       "82   111619     76     0    3039924.0  \n",
       "128  118116    119     0    4759881.0  \n",
       "120   94591   1437    0瓶   27301563.0  \n",
       "147   85641   1421    0瓶   15771679.0  \n",
       "106   77894   1665    0瓶   13318335.0  \n",
       "125   63697   1560    0瓶   12478440.0  \n",
       "148  478854  14175  仅供展示  110479950.0  \n",
       "110   39405   1604    0瓶   12028396.0  \n",
       "134   45043   1607    0瓶   11086693.0  \n",
       "136   43369   1572    0瓶   10373628.0  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "maotai_price_0816.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>时间</th>\n",
       "      <th>商品名</th>\n",
       "      <th>商品编号</th>\n",
       "      <th>品牌</th>\n",
       "      <th>价格</th>\n",
       "      <th>浏览量</th>\n",
       "      <th>已售出量</th>\n",
       "      <th>库存量</th>\n",
       "      <th>销售额</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 新飞天茅台酒53度500ml茅台官方商城正品直供</td>\n",
       "      <td>23</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1299.0</td>\n",
       "      <td>2825761</td>\n",
       "      <td>142409</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>184989291.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒（2017丁酉鸡年）53度500ml【按农历生肖属相推出】</td>\n",
       "      <td>1618</td>\n",
       "      <td>生肖纪念酒</td>\n",
       "      <td>1599.0</td>\n",
       "      <td>4500116</td>\n",
       "      <td>41097</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>65714103.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 五星茅台酒53度500ml 茅台官方商城正品直供</td>\n",
       "      <td>3</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1289.0</td>\n",
       "      <td>377555</td>\n",
       "      <td>14397</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>18557733.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒新飞天茅台53度500ml（6瓶整箱购买）茅台官方商城正品直供</td>\n",
       "      <td>1044</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>7794.0</td>\n",
       "      <td>478854</td>\n",
       "      <td>14175</td>\n",
       "      <td>仅供展示</td>\n",
       "      <td>110479950.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 飞天茅台酒53度200ml茅台官方商城正品直供</td>\n",
       "      <td>5</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>589.0</td>\n",
       "      <td>125573</td>\n",
       "      <td>6372</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>3753108.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 飞天茅台酒53度375ml茅台官方商城正品直供</td>\n",
       "      <td>2</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>999.0</td>\n",
       "      <td>129509</td>\n",
       "      <td>5463</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>5457537.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>丙申猴年茅台酒53度500ml贵州茅台酒(按农历生肖属相推出)</td>\n",
       "      <td>1450</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>2999.0</td>\n",
       "      <td>568479</td>\n",
       "      <td>5024</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>15066976.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台王子酒 53度500ml 酱门经典</td>\n",
       "      <td>461</td>\n",
       "      <td>茅台王子酒</td>\n",
       "      <td>289.0</td>\n",
       "      <td>63704</td>\n",
       "      <td>4970</td>\n",
       "      <td>65瓶</td>\n",
       "      <td>1436330.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州大曲2.5L坛装纪念版53度</td>\n",
       "      <td>1286</td>\n",
       "      <td>贵州大曲</td>\n",
       "      <td>1599.0</td>\n",
       "      <td>207597</td>\n",
       "      <td>4885</td>\n",
       "      <td>0</td>\n",
       "      <td>7811115.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒新飞天茅台酒53度500ml茅台商城专享版【2014年生产】茅台官方商城正品直供</td>\n",
       "      <td>1080</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1799.0</td>\n",
       "      <td>310354</td>\n",
       "      <td>3514</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>6321686.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             时间                                             商品名  商品编号     品牌  \\\n",
       "98   2017-08-16                  贵州茅台酒 新飞天茅台酒53度500ml茅台官方商城正品直供    23  贵州茅台酒   \n",
       "114  2017-08-16              贵州茅台酒（2017丁酉鸡年）53度500ml【按农历生肖属相推出】  1618  生肖纪念酒   \n",
       "115  2017-08-16                  贵州茅台酒 五星茅台酒53度500ml 茅台官方商城正品直供     3  贵州茅台酒   \n",
       "148  2017-08-16            贵州茅台酒新飞天茅台53度500ml（6瓶整箱购买）茅台官方商城正品直供  1044  贵州茅台酒   \n",
       "153  2017-08-16                   贵州茅台酒 飞天茅台酒53度200ml茅台官方商城正品直供     5  贵州茅台酒   \n",
       "90   2017-08-16                   贵州茅台酒 飞天茅台酒53度375ml茅台官方商城正品直供     2  贵州茅台酒   \n",
       "159  2017-08-16                 丙申猴年茅台酒53度500ml贵州茅台酒(按农历生肖属相推出)  1450  贵州茅台酒   \n",
       "92   2017-08-16                             茅台王子酒 53度500ml 酱门经典   461  茅台王子酒   \n",
       "107  2017-08-16                                贵州大曲2.5L坛装纪念版53度  1286   贵州大曲   \n",
       "99   2017-08-16   贵州茅台酒新飞天茅台酒53度500ml茅台商城专享版【2014年生产】茅台官方商城正品直供  1080  贵州茅台酒   \n",
       "\n",
       "         价格      浏览量    已售出量   库存量          销售额  \n",
       "98   1299.0  2825761  142409    0瓶  184989291.0  \n",
       "114  1599.0  4500116   41097    0瓶   65714103.0  \n",
       "115  1289.0   377555   14397    0瓶   18557733.0  \n",
       "148  7794.0   478854   14175  仅供展示  110479950.0  \n",
       "153   589.0   125573    6372    0瓶    3753108.0  \n",
       "90    999.0   129509    5463    0瓶    5457537.0  \n",
       "159  2999.0   568479    5024    0瓶   15066976.0  \n",
       "92    289.0    63704    4970   65瓶    1436330.0  \n",
       "107  1599.0   207597    4885     0    7811115.0  \n",
       "99   1799.0   310354    3514    0瓶    6321686.0  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "maotai_sales_count_0816.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>时间</th>\n",
       "      <th>商品名</th>\n",
       "      <th>商品编号</th>\n",
       "      <th>品牌</th>\n",
       "      <th>价格</th>\n",
       "      <th>浏览量</th>\n",
       "      <th>已售出量</th>\n",
       "      <th>库存量</th>\n",
       "      <th>销售额</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>2017-08-08</td>\n",
       "      <td>贵州茅台酒 新飞天茅台酒53度500ml茅台官方商城正品直供</td>\n",
       "      <td>23</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1299.0</td>\n",
       "      <td>2549637</td>\n",
       "      <td>138833</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>180344067.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>2017-08-08</td>\n",
       "      <td>贵州茅台酒（2017丁酉鸡年）53度500ml【按农历生肖属相推出】</td>\n",
       "      <td>1618</td>\n",
       "      <td>生肖纪念酒</td>\n",
       "      <td>1599.0</td>\n",
       "      <td>4079797</td>\n",
       "      <td>40317</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>64466883.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>2017-08-08</td>\n",
       "      <td>贵州茅台酒 五星茅台酒53度500ml 茅台官方商城正品直供</td>\n",
       "      <td>3</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1289.0</td>\n",
       "      <td>361777</td>\n",
       "      <td>14397</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>18557733.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>2017-08-08</td>\n",
       "      <td>贵州茅台酒新飞天茅台53度500ml（6瓶整箱购买）茅台官方商城正品直供</td>\n",
       "      <td>1044</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>7794.0</td>\n",
       "      <td>453173</td>\n",
       "      <td>14175</td>\n",
       "      <td>仅供展示</td>\n",
       "      <td>110479950.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2017-08-08</td>\n",
       "      <td>贵州茅台酒 飞天茅台酒53度200ml茅台官方商城正品直供</td>\n",
       "      <td>5</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>589.0</td>\n",
       "      <td>123244</td>\n",
       "      <td>6372</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>3753108.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2017-08-08</td>\n",
       "      <td>贵州茅台酒 飞天茅台酒53度375ml茅台官方商城正品直供</td>\n",
       "      <td>2</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>999.0</td>\n",
       "      <td>126473</td>\n",
       "      <td>5463</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>5457537.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>2017-08-08</td>\n",
       "      <td>丙申猴年茅台酒53度500ml贵州茅台酒(按农历生肖属相推出)</td>\n",
       "      <td>1450</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>2999.0</td>\n",
       "      <td>564437</td>\n",
       "      <td>5024</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>15066976.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2017-08-08</td>\n",
       "      <td>茅台王子酒 53度500ml 酱门经典</td>\n",
       "      <td>461</td>\n",
       "      <td>茅台王子酒</td>\n",
       "      <td>289.0</td>\n",
       "      <td>63073</td>\n",
       "      <td>4938</td>\n",
       "      <td>136瓶</td>\n",
       "      <td>1427082.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>2017-08-08</td>\n",
       "      <td>贵州大曲2.5L坛装纪念版53度</td>\n",
       "      <td>1286</td>\n",
       "      <td>贵州大曲</td>\n",
       "      <td>1599.0</td>\n",
       "      <td>206723</td>\n",
       "      <td>4885</td>\n",
       "      <td>0</td>\n",
       "      <td>7811115.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2017-08-08</td>\n",
       "      <td>贵州茅台酒新飞天茅台酒53度500ml茅台商城专享版【2014年生产】茅台官方商城正品直供</td>\n",
       "      <td>1080</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1799.0</td>\n",
       "      <td>306765</td>\n",
       "      <td>3514</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>6321686.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            时间                                             商品名  商品编号     品牌  \\\n",
       "67  2017-08-08                  贵州茅台酒 新飞天茅台酒53度500ml茅台官方商城正品直供    23  贵州茅台酒   \n",
       "72  2017-08-08              贵州茅台酒（2017丁酉鸡年）53度500ml【按农历生肖属相推出】  1618  生肖纪念酒   \n",
       "75  2017-08-08                  贵州茅台酒 五星茅台酒53度500ml 茅台官方商城正品直供     3  贵州茅台酒   \n",
       "76  2017-08-08            贵州茅台酒新飞天茅台53度500ml（6瓶整箱购买）茅台官方商城正品直供  1044  贵州茅台酒   \n",
       "58  2017-08-08                   贵州茅台酒 飞天茅台酒53度200ml茅台官方商城正品直供     5  贵州茅台酒   \n",
       "12  2017-08-08                   贵州茅台酒 飞天茅台酒53度375ml茅台官方商城正品直供     2  贵州茅台酒   \n",
       "70  2017-08-08                 丙申猴年茅台酒53度500ml贵州茅台酒(按农历生肖属相推出)  1450  贵州茅台酒   \n",
       "54  2017-08-08                             茅台王子酒 53度500ml 酱门经典   461  茅台王子酒   \n",
       "57  2017-08-08                                贵州大曲2.5L坛装纪念版53度  1286   贵州大曲   \n",
       "5   2017-08-08   贵州茅台酒新飞天茅台酒53度500ml茅台商城专享版【2014年生产】茅台官方商城正品直供  1080  贵州茅台酒   \n",
       "\n",
       "        价格      浏览量    已售出量   库存量          销售额  \n",
       "67  1299.0  2549637  138833    0瓶  180344067.0  \n",
       "72  1599.0  4079797   40317    0瓶   64466883.0  \n",
       "75  1289.0   361777   14397    0瓶   18557733.0  \n",
       "76  7794.0   453173   14175  仅供展示  110479950.0  \n",
       "58   589.0   123244    6372    0瓶    3753108.0  \n",
       "12   999.0   126473    5463    0瓶    5457537.0  \n",
       "70  2999.0   564437    5024    0瓶   15066976.0  \n",
       "54   289.0    63073    4938  136瓶    1427082.0  \n",
       "57  1599.0   206723    4885     0    7811115.0  \n",
       "5   1799.0   306765    3514    0瓶    6321686.0  "
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "maotai_sales_count_0808.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>时间</th>\n",
       "      <th>商品名</th>\n",
       "      <th>商品编号</th>\n",
       "      <th>品牌</th>\n",
       "      <th>价格</th>\n",
       "      <th>浏览量</th>\n",
       "      <th>已售出量</th>\n",
       "      <th>库存量</th>\n",
       "      <th>销售额</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 新飞天茅台酒53度500ml茅台官方商城正品直供</td>\n",
       "      <td>23</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1299.0</td>\n",
       "      <td>2825761</td>\n",
       "      <td>142409</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>184989291.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒新飞天茅台53度500ml（6瓶整箱购买）茅台官方商城正品直供</td>\n",
       "      <td>1044</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>7794.0</td>\n",
       "      <td>478854</td>\n",
       "      <td>14175</td>\n",
       "      <td>仅供展示</td>\n",
       "      <td>110479950.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒（2017丁酉鸡年）53度500ml【按农历生肖属相推出】</td>\n",
       "      <td>1618</td>\n",
       "      <td>生肖纪念酒</td>\n",
       "      <td>1599.0</td>\n",
       "      <td>4500116</td>\n",
       "      <td>41097</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>65714103.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 50年 53度500ml</td>\n",
       "      <td>17</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>18999.0</td>\n",
       "      <td>94591</td>\n",
       "      <td>1437</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>27301563.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 五星茅台酒53度500ml 茅台官方商城正品直供</td>\n",
       "      <td>3</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1289.0</td>\n",
       "      <td>377555</td>\n",
       "      <td>14397</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>18557733.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 五星53度500ml(甲午马年)（按农历生肖属相推出）</td>\n",
       "      <td>1144</td>\n",
       "      <td>生肖纪念酒</td>\n",
       "      <td>5999.0</td>\n",
       "      <td>288473</td>\n",
       "      <td>2837</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>17019163.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 30年 53度500ml</td>\n",
       "      <td>18</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>11099.0</td>\n",
       "      <td>85641</td>\n",
       "      <td>1421</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>15771679.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>丙申猴年茅台酒53度500ml贵州茅台酒(按农历生肖属相推出)</td>\n",
       "      <td>1450</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>2999.0</td>\n",
       "      <td>568479</td>\n",
       "      <td>5024</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>15066976.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒15年53度500ml</td>\n",
       "      <td>25</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>4799.0</td>\n",
       "      <td>203558</td>\n",
       "      <td>2830</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>13581170.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 五星53度500ml(2000年)</td>\n",
       "      <td>289</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>7999.0</td>\n",
       "      <td>77894</td>\n",
       "      <td>1665</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>13318335.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             时间                                    商品名  商品编号     品牌       价格  \\\n",
       "98   2017-08-16         贵州茅台酒 新飞天茅台酒53度500ml茅台官方商城正品直供    23  贵州茅台酒   1299.0   \n",
       "148  2017-08-16   贵州茅台酒新飞天茅台53度500ml（6瓶整箱购买）茅台官方商城正品直供  1044  贵州茅台酒   7794.0   \n",
       "114  2017-08-16     贵州茅台酒（2017丁酉鸡年）53度500ml【按农历生肖属相推出】  1618  生肖纪念酒   1599.0   \n",
       "120  2017-08-16                     贵州茅台酒 50年 53度500ml    17  贵州茅台酒  18999.0   \n",
       "115  2017-08-16         贵州茅台酒 五星茅台酒53度500ml 茅台官方商城正品直供     3  贵州茅台酒   1289.0   \n",
       "100  2017-08-16        茅台酒 五星53度500ml(甲午马年)（按农历生肖属相推出）  1144  生肖纪念酒   5999.0   \n",
       "147  2017-08-16                     贵州茅台酒 30年 53度500ml    18  贵州茅台酒  11099.0   \n",
       "159  2017-08-16        丙申猴年茅台酒53度500ml贵州茅台酒(按农历生肖属相推出)  1450  贵州茅台酒   2999.0   \n",
       "133  2017-08-16                       贵州茅台酒15年53度500ml    25  贵州茅台酒   4799.0   \n",
       "106  2017-08-16                  茅台酒 五星53度500ml(2000年)   289  贵州茅台酒   7999.0   \n",
       "\n",
       "         浏览量    已售出量   库存量          销售额  \n",
       "98   2825761  142409    0瓶  184989291.0  \n",
       "148   478854   14175  仅供展示  110479950.0  \n",
       "114  4500116   41097    0瓶   65714103.0  \n",
       "120    94591    1437    0瓶   27301563.0  \n",
       "115   377555   14397    0瓶   18557733.0  \n",
       "100   288473    2837    0瓶   17019163.0  \n",
       "147    85641    1421    0瓶   15771679.0  \n",
       "159   568479    5024    0瓶   15066976.0  \n",
       "133   203558    2830    0瓶   13581170.0  \n",
       "106    77894    1665    0瓶   13318335.0  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "maotai_sales_income_0816.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>时间</th>\n",
       "      <th>商品名</th>\n",
       "      <th>商品编号</th>\n",
       "      <th>品牌</th>\n",
       "      <th>价格</th>\n",
       "      <th>浏览量</th>\n",
       "      <th>已售出量</th>\n",
       "      <th>库存量</th>\n",
       "      <th>销售额</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒（2017丁酉鸡年）53度500ml【按农历生肖属相推出】</td>\n",
       "      <td>1618</td>\n",
       "      <td>生肖纪念酒</td>\n",
       "      <td>1599.0</td>\n",
       "      <td>4500116</td>\n",
       "      <td>41097</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>65714103.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 新飞天茅台酒53度500ml茅台官方商城正品直供</td>\n",
       "      <td>23</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1299.0</td>\n",
       "      <td>2825761</td>\n",
       "      <td>142409</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>184989291.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>丙申猴年茅台酒53度500ml贵州茅台酒(按农历生肖属相推出)</td>\n",
       "      <td>1450</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>2999.0</td>\n",
       "      <td>568479</td>\n",
       "      <td>5024</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>15066976.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒新飞天茅台53度500ml（6瓶整箱购买）茅台官方商城正品直供</td>\n",
       "      <td>1044</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>7794.0</td>\n",
       "      <td>478854</td>\n",
       "      <td>14175</td>\n",
       "      <td>仅供展示</td>\n",
       "      <td>110479950.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 五星茅台酒53度500ml 茅台官方商城正品直供</td>\n",
       "      <td>3</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1289.0</td>\n",
       "      <td>377555</td>\n",
       "      <td>14397</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>18557733.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒新飞天茅台酒53度500ml茅台商城专享版【2014年生产】茅台官方商城正品直供</td>\n",
       "      <td>1080</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1799.0</td>\n",
       "      <td>310354</td>\n",
       "      <td>3514</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>6321686.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 五星53度500ml(甲午马年)（按农历生肖属相推出）</td>\n",
       "      <td>1144</td>\n",
       "      <td>生肖纪念酒</td>\n",
       "      <td>5999.0</td>\n",
       "      <td>288473</td>\n",
       "      <td>2837</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>17019163.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>53度500ml五星茅台酒（乙未羊年）（按农历生肖属相推出）</td>\n",
       "      <td>1214</td>\n",
       "      <td>生肖纪念酒</td>\n",
       "      <td>5999.0</td>\n",
       "      <td>274376</td>\n",
       "      <td>1593</td>\n",
       "      <td>0</td>\n",
       "      <td>9556407.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>百年金奖辉煌贵州茅台酒53度500ml</td>\n",
       "      <td>1111</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>3509.0</td>\n",
       "      <td>267162</td>\n",
       "      <td>2502</td>\n",
       "      <td>仅供展示</td>\n",
       "      <td>8779518.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州大曲2.5L坛装纪念版53度</td>\n",
       "      <td>1286</td>\n",
       "      <td>贵州大曲</td>\n",
       "      <td>1599.0</td>\n",
       "      <td>207597</td>\n",
       "      <td>4885</td>\n",
       "      <td>0</td>\n",
       "      <td>7811115.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             时间                                             商品名  商品编号     品牌  \\\n",
       "114  2017-08-16              贵州茅台酒（2017丁酉鸡年）53度500ml【按农历生肖属相推出】  1618  生肖纪念酒   \n",
       "98   2017-08-16                  贵州茅台酒 新飞天茅台酒53度500ml茅台官方商城正品直供    23  贵州茅台酒   \n",
       "159  2017-08-16                 丙申猴年茅台酒53度500ml贵州茅台酒(按农历生肖属相推出)  1450  贵州茅台酒   \n",
       "148  2017-08-16            贵州茅台酒新飞天茅台53度500ml（6瓶整箱购买）茅台官方商城正品直供  1044  贵州茅台酒   \n",
       "115  2017-08-16                  贵州茅台酒 五星茅台酒53度500ml 茅台官方商城正品直供     3  贵州茅台酒   \n",
       "99   2017-08-16   贵州茅台酒新飞天茅台酒53度500ml茅台商城专享版【2014年生产】茅台官方商城正品直供  1080  贵州茅台酒   \n",
       "100  2017-08-16                 茅台酒 五星53度500ml(甲午马年)（按农历生肖属相推出）  1144  生肖纪念酒   \n",
       "151  2017-08-16                  53度500ml五星茅台酒（乙未羊年）（按农历生肖属相推出）  1214  生肖纪念酒   \n",
       "152  2017-08-16                             百年金奖辉煌贵州茅台酒53度500ml  1111  贵州茅台酒   \n",
       "107  2017-08-16                                贵州大曲2.5L坛装纪念版53度  1286   贵州大曲   \n",
       "\n",
       "         价格      浏览量    已售出量   库存量          销售额  \n",
       "114  1599.0  4500116   41097    0瓶   65714103.0  \n",
       "98   1299.0  2825761  142409    0瓶  184989291.0  \n",
       "159  2999.0   568479    5024    0瓶   15066976.0  \n",
       "148  7794.0   478854   14175  仅供展示  110479950.0  \n",
       "115  1289.0   377555   14397    0瓶   18557733.0  \n",
       "99   1799.0   310354    3514    0瓶    6321686.0  \n",
       "100  5999.0   288473    2837    0瓶   17019163.0  \n",
       "151  5999.0   274376    1593     0    9556407.0  \n",
       "152  3509.0   267162    2502  仅供展示    8779518.0  \n",
       "107  1599.0   207597    4885     0    7811115.0  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "maotai_view_count_0816.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>时间</th>\n",
       "      <th>商品名</th>\n",
       "      <th>商品编号</th>\n",
       "      <th>价格</th>\n",
       "      <th>浏览量</th>\n",
       "      <th>已售出量</th>\n",
       "      <th>库存量</th>\n",
       "      <th>销售额</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>品牌</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>仁酒</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华茅酒</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>汉酱酒</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>王茅酒</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>生肖纪念酒</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>茅台王子酒</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>茅台迎宾酒</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>贵州大曲</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>贵州茅台酒</th>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>赖茅酒</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       时间  商品名  商品编号  价格  浏览量  已售出量  库存量  销售额\n",
       "品牌                                           \n",
       "仁酒      5    5     5   5    5     5    5    5\n",
       "华茅酒     2    2     2   2    2     2    2    2\n",
       "汉酱酒     5    5     5   5    5     5    5    5\n",
       "王茅酒     2    2     2   2    2     2    2    2\n",
       "生肖纪念酒   5    5     5   5    5     5    5    5\n",
       "茅台王子酒   6    6     6   6    6     6    6    6\n",
       "茅台迎宾酒   9    9     9   9    9     9    9    9\n",
       "贵州大曲    3    3     3   3    3     3    3    3\n",
       "贵州茅台酒  40   40    40  40   40    40   40   40\n",
       "赖茅酒     3    3     3   3    3     3    3    3"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "emaotai_0816.groupby('品牌').count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>时间</th>\n",
       "      <th>商品名</th>\n",
       "      <th>商品编号</th>\n",
       "      <th>品牌</th>\n",
       "      <th>价格</th>\n",
       "      <th>浏览量</th>\n",
       "      <th>已售出量</th>\n",
       "      <th>库存量</th>\n",
       "      <th>销售额</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 小号木珍53度500ml</td>\n",
       "      <td>11</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1539.0</td>\n",
       "      <td>76414</td>\n",
       "      <td>1262</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>1942218.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 五星53度500ml(2003年)</td>\n",
       "      <td>292</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>6599.0</td>\n",
       "      <td>63671</td>\n",
       "      <td>1612</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>10637588.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 新飞天茅台酒43度500ml茅台官方商城正品直供</td>\n",
       "      <td>50</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>859.0</td>\n",
       "      <td>109757</td>\n",
       "      <td>3044</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>2614796.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 飞天茅台酒53度375ml茅台官方商城正品直供</td>\n",
       "      <td>2</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>999.0</td>\n",
       "      <td>129509</td>\n",
       "      <td>5463</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>5457537.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>2014秋季糖酒会纪念 茅台酒 53度500ml</td>\n",
       "      <td>1084</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1899.0</td>\n",
       "      <td>72239</td>\n",
       "      <td>369</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>700731.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 五星53度500ml(2004年)</td>\n",
       "      <td>298</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>6199.0</td>\n",
       "      <td>65985</td>\n",
       "      <td>1560</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>9670440.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 五星53度500ml(2005年)</td>\n",
       "      <td>363</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>5889.0</td>\n",
       "      <td>73128</td>\n",
       "      <td>1604</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>9445956.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 53度50mLx5（白色条装）</td>\n",
       "      <td>1339</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>729.0</td>\n",
       "      <td>136984</td>\n",
       "      <td>1179</td>\n",
       "      <td>0套</td>\n",
       "      <td>859491.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 新飞天茅台酒53度500ml茅台官方商城正品直供</td>\n",
       "      <td>23</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1299.0</td>\n",
       "      <td>2825761</td>\n",
       "      <td>142409</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>184989291.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒新飞天茅台酒53度500ml茅台商城专享版【2014年生产】茅台官方商城正品直供</td>\n",
       "      <td>1080</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1799.0</td>\n",
       "      <td>310354</td>\n",
       "      <td>3514</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>6321686.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 53度500ml茅台酒（第五届酒博会纪念）</td>\n",
       "      <td>1337</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1899.0</td>\n",
       "      <td>177292</td>\n",
       "      <td>552</td>\n",
       "      <td>0</td>\n",
       "      <td>1048248.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 紫砂纸珍53度500ml</td>\n",
       "      <td>407</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>2289.0</td>\n",
       "      <td>188015</td>\n",
       "      <td>2103</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>4813767.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 五星53度500ml(2000年)</td>\n",
       "      <td>289</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>7999.0</td>\n",
       "      <td>77894</td>\n",
       "      <td>1665</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>13318335.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 53度50ml*5（金色条装）内含5瓶53度50ml贵州茅台酒</td>\n",
       "      <td>1340</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>739.0</td>\n",
       "      <td>178192</td>\n",
       "      <td>2821</td>\n",
       "      <td>0</td>\n",
       "      <td>2084719.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 飞天53度500ml(2001年)</td>\n",
       "      <td>294</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>7499.0</td>\n",
       "      <td>39405</td>\n",
       "      <td>1604</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>12028396.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 飞天茅台酒53度50ml*2茅台官方商城正品直供</td>\n",
       "      <td>6</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>358.0</td>\n",
       "      <td>156778</td>\n",
       "      <td>3491</td>\n",
       "      <td>0盒</td>\n",
       "      <td>1249778.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 大号木珍53度500ml</td>\n",
       "      <td>22</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1709.0</td>\n",
       "      <td>57883</td>\n",
       "      <td>1034</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>1767106.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 五星茅台酒53度500ml 茅台官方商城正品直供</td>\n",
       "      <td>3</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1289.0</td>\n",
       "      <td>377555</td>\n",
       "      <td>14397</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>18557733.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 53度500ml茅台酒（第四届贵州酒博会纪念）</td>\n",
       "      <td>1079</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>2199.0</td>\n",
       "      <td>66696</td>\n",
       "      <td>268</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>589332.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>【新品】贵州茅台酒第六届酒博会纪念酒53度500ml</td>\n",
       "      <td>1578</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1599.0</td>\n",
       "      <td>157780</td>\n",
       "      <td>1503</td>\n",
       "      <td>0</td>\n",
       "      <td>2403297.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 50年 53度500ml</td>\n",
       "      <td>17</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>18999.0</td>\n",
       "      <td>94591</td>\n",
       "      <td>1437</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>27301563.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 飞天53度500ml(2000年)</td>\n",
       "      <td>293</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>7999.0</td>\n",
       "      <td>63697</td>\n",
       "      <td>1560</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>12478440.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>中国酒业名酒收藏委员会成立大会纪念茅台酒 飞天53度500ml</td>\n",
       "      <td>922</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>2999.0</td>\n",
       "      <td>110208</td>\n",
       "      <td>1681</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>5041319.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 新飞天53度500ml(2005年)</td>\n",
       "      <td>367</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>5899.0</td>\n",
       "      <td>48043</td>\n",
       "      <td>1721</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>10152179.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒15年53度500ml</td>\n",
       "      <td>25</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>4799.0</td>\n",
       "      <td>203558</td>\n",
       "      <td>2830</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>13581170.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 飞天53度500ml(2002年)</td>\n",
       "      <td>295</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>6899.0</td>\n",
       "      <td>45043</td>\n",
       "      <td>1607</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>11086693.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 飞天53度500ml(2003年)</td>\n",
       "      <td>296</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>6599.0</td>\n",
       "      <td>43369</td>\n",
       "      <td>1572</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>10373628.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 飞天茅台酒53度1000ml茅台官方商城正品直供</td>\n",
       "      <td>483</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>2799.0</td>\n",
       "      <td>178998</td>\n",
       "      <td>3366</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>9421434.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 豪华装绛色53度500ml</td>\n",
       "      <td>47</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1499.0</td>\n",
       "      <td>60865</td>\n",
       "      <td>1565</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>2345935.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 浮雕木珍53度500ml</td>\n",
       "      <td>233</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>2849.0</td>\n",
       "      <td>73723</td>\n",
       "      <td>1102</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>3139598.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>茅台酒 茅台二套装</td>\n",
       "      <td>44</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>2209.0</td>\n",
       "      <td>57623</td>\n",
       "      <td>915</td>\n",
       "      <td>仅供展示</td>\n",
       "      <td>2021235.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 茅台四套装</td>\n",
       "      <td>40</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>3199.0</td>\n",
       "      <td>69530</td>\n",
       "      <td>1155</td>\n",
       "      <td>0盒</td>\n",
       "      <td>3694845.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 30年 53度500ml</td>\n",
       "      <td>18</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>11099.0</td>\n",
       "      <td>85641</td>\n",
       "      <td>1421</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>15771679.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒新飞天茅台53度500ml（6瓶整箱购买）茅台官方商城正品直供</td>\n",
       "      <td>1044</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>7794.0</td>\n",
       "      <td>478854</td>\n",
       "      <td>14175</td>\n",
       "      <td>仅供展示</td>\n",
       "      <td>110479950.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>百年金奖辉煌贵州茅台酒53度500ml</td>\n",
       "      <td>1111</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>3509.0</td>\n",
       "      <td>267162</td>\n",
       "      <td>2502</td>\n",
       "      <td>仅供展示</td>\n",
       "      <td>8779518.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 飞天茅台酒53度200ml茅台官方商城正品直供</td>\n",
       "      <td>5</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>589.0</td>\n",
       "      <td>125573</td>\n",
       "      <td>6372</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>3753108.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 豪华装金色53度500ml</td>\n",
       "      <td>48</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1489.0</td>\n",
       "      <td>70757</td>\n",
       "      <td>1229</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>1829981.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>丙申猴年茅台酒53度500ml贵州茅台酒(按农历生肖属相推出)</td>\n",
       "      <td>1450</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>2999.0</td>\n",
       "      <td>568479</td>\n",
       "      <td>5024</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>15066976.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒 纸珍53度375ml</td>\n",
       "      <td>9</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1389.0</td>\n",
       "      <td>55554</td>\n",
       "      <td>997</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>1384833.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>贵州茅台酒(纪念中国人民抗日战争暨世界反法西斯战争胜利70周年)53度500ml</td>\n",
       "      <td>1338</td>\n",
       "      <td>贵州茅台酒</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>197351</td>\n",
       "      <td>2344</td>\n",
       "      <td>0瓶</td>\n",
       "      <td>4685656.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             时间                                             商品名  商品编号     品牌  \\\n",
       "83   2017-08-16                              贵州茅台酒 小号木珍53度500ml    11  贵州茅台酒   \n",
       "84   2017-08-16                           茅台酒 五星53度500ml(2003年)   292  贵州茅台酒   \n",
       "87   2017-08-16                  贵州茅台酒 新飞天茅台酒43度500ml茅台官方商城正品直供    50  贵州茅台酒   \n",
       "90   2017-08-16                   贵州茅台酒 飞天茅台酒53度375ml茅台官方商城正品直供     2  贵州茅台酒   \n",
       "93   2017-08-16                        2014秋季糖酒会纪念 茅台酒 53度500ml  1084  贵州茅台酒   \n",
       "94   2017-08-16                           茅台酒 五星53度500ml(2004年)   298  贵州茅台酒   \n",
       "95   2017-08-16                           茅台酒 五星53度500ml(2005年)   363  贵州茅台酒   \n",
       "96   2017-08-16                           贵州茅台酒 53度50mLx5（白色条装）  1339  贵州茅台酒   \n",
       "98   2017-08-16                  贵州茅台酒 新飞天茅台酒53度500ml茅台官方商城正品直供    23  贵州茅台酒   \n",
       "99   2017-08-16   贵州茅台酒新飞天茅台酒53度500ml茅台商城专享版【2014年生产】茅台官方商城正品直供  1080  贵州茅台酒   \n",
       "102  2017-08-16                       茅台酒 53度500ml茅台酒（第五届酒博会纪念）  1337  贵州茅台酒   \n",
       "104  2017-08-16                              贵州茅台酒 紫砂纸珍53度500ml   407  贵州茅台酒   \n",
       "106  2017-08-16                           茅台酒 五星53度500ml(2000年)   289  贵州茅台酒   \n",
       "109  2017-08-16           贵州茅台酒 53度50ml*5（金色条装）内含5瓶53度50ml贵州茅台酒  1340  贵州茅台酒   \n",
       "110  2017-08-16                           茅台酒 飞天53度500ml(2001年)   294  贵州茅台酒   \n",
       "112  2017-08-16                  贵州茅台酒 飞天茅台酒53度50ml*2茅台官方商城正品直供     6  贵州茅台酒   \n",
       "113  2017-08-16                              贵州茅台酒 大号木珍53度500ml    22  贵州茅台酒   \n",
       "115  2017-08-16                  贵州茅台酒 五星茅台酒53度500ml 茅台官方商城正品直供     3  贵州茅台酒   \n",
       "116  2017-08-16                     茅台酒 53度500ml茅台酒（第四届贵州酒博会纪念）  1079  贵州茅台酒   \n",
       "119  2017-08-16                      【新品】贵州茅台酒第六届酒博会纪念酒53度500ml  1578  贵州茅台酒   \n",
       "120  2017-08-16                              贵州茅台酒 50年 53度500ml    17  贵州茅台酒   \n",
       "125  2017-08-16                           茅台酒 飞天53度500ml(2000年)   293  贵州茅台酒   \n",
       "126  2017-08-16                 中国酒业名酒收藏委员会成立大会纪念茅台酒 飞天53度500ml   922  贵州茅台酒   \n",
       "132  2017-08-16                          茅台酒 新飞天53度500ml(2005年)   367  贵州茅台酒   \n",
       "133  2017-08-16                                贵州茅台酒15年53度500ml    25  贵州茅台酒   \n",
       "134  2017-08-16                           茅台酒 飞天53度500ml(2002年)   295  贵州茅台酒   \n",
       "136  2017-08-16                           茅台酒 飞天53度500ml(2003年)   296  贵州茅台酒   \n",
       "137  2017-08-16                  贵州茅台酒 飞天茅台酒53度1000ml茅台官方商城正品直供   483  贵州茅台酒   \n",
       "140  2017-08-16                             贵州茅台酒 豪华装绛色53度500ml    47  贵州茅台酒   \n",
       "141  2017-08-16                              贵州茅台酒 浮雕木珍53度500ml   233  贵州茅台酒   \n",
       "142  2017-08-16                                       茅台酒 茅台二套装    44  贵州茅台酒   \n",
       "146  2017-08-16                                     贵州茅台酒 茅台四套装    40  贵州茅台酒   \n",
       "147  2017-08-16                              贵州茅台酒 30年 53度500ml    18  贵州茅台酒   \n",
       "148  2017-08-16            贵州茅台酒新飞天茅台53度500ml（6瓶整箱购买）茅台官方商城正品直供  1044  贵州茅台酒   \n",
       "152  2017-08-16                             百年金奖辉煌贵州茅台酒53度500ml  1111  贵州茅台酒   \n",
       "153  2017-08-16                   贵州茅台酒 飞天茅台酒53度200ml茅台官方商城正品直供     5  贵州茅台酒   \n",
       "155  2017-08-16                             贵州茅台酒 豪华装金色53度500ml    48  贵州茅台酒   \n",
       "159  2017-08-16                 丙申猴年茅台酒53度500ml贵州茅台酒(按农历生肖属相推出)  1450  贵州茅台酒   \n",
       "160  2017-08-16                                贵州茅台酒 纸珍53度375ml     9  贵州茅台酒   \n",
       "161  2017-08-16        贵州茅台酒(纪念中国人民抗日战争暨世界反法西斯战争胜利70周年)53度500ml  1338  贵州茅台酒   \n",
       "\n",
       "          价格      浏览量    已售出量   库存量          销售额  \n",
       "83    1539.0    76414    1262    0瓶    1942218.0  \n",
       "84    6599.0    63671    1612    0瓶   10637588.0  \n",
       "87     859.0   109757    3044    0瓶    2614796.0  \n",
       "90     999.0   129509    5463    0瓶    5457537.0  \n",
       "93    1899.0    72239     369    0瓶     700731.0  \n",
       "94    6199.0    65985    1560    0瓶    9670440.0  \n",
       "95    5889.0    73128    1604    0瓶    9445956.0  \n",
       "96     729.0   136984    1179    0套     859491.0  \n",
       "98    1299.0  2825761  142409    0瓶  184989291.0  \n",
       "99    1799.0   310354    3514    0瓶    6321686.0  \n",
       "102   1899.0   177292     552     0    1048248.0  \n",
       "104   2289.0   188015    2103    0瓶    4813767.0  \n",
       "106   7999.0    77894    1665    0瓶   13318335.0  \n",
       "109    739.0   178192    2821     0    2084719.0  \n",
       "110   7499.0    39405    1604    0瓶   12028396.0  \n",
       "112    358.0   156778    3491    0盒    1249778.0  \n",
       "113   1709.0    57883    1034    0瓶    1767106.0  \n",
       "115   1289.0   377555   14397    0瓶   18557733.0  \n",
       "116   2199.0    66696     268    0瓶     589332.0  \n",
       "119   1599.0   157780    1503     0    2403297.0  \n",
       "120  18999.0    94591    1437    0瓶   27301563.0  \n",
       "125   7999.0    63697    1560    0瓶   12478440.0  \n",
       "126   2999.0   110208    1681    0瓶    5041319.0  \n",
       "132   5899.0    48043    1721    0瓶   10152179.0  \n",
       "133   4799.0   203558    2830    0瓶   13581170.0  \n",
       "134   6899.0    45043    1607    0瓶   11086693.0  \n",
       "136   6599.0    43369    1572    0瓶   10373628.0  \n",
       "137   2799.0   178998    3366    0瓶    9421434.0  \n",
       "140   1499.0    60865    1565    0瓶    2345935.0  \n",
       "141   2849.0    73723    1102    0瓶    3139598.0  \n",
       "142   2209.0    57623     915  仅供展示    2021235.0  \n",
       "146   3199.0    69530    1155    0盒    3694845.0  \n",
       "147  11099.0    85641    1421    0瓶   15771679.0  \n",
       "148   7794.0   478854   14175  仅供展示  110479950.0  \n",
       "152   3509.0   267162    2502  仅供展示    8779518.0  \n",
       "153    589.0   125573    6372    0瓶    3753108.0  \n",
       "155   1489.0    70757    1229    0瓶    1829981.0  \n",
       "159   2999.0   568479    5024    0瓶   15066976.0  \n",
       "160   1389.0    55554     997    0瓶    1384833.0  \n",
       "161   1999.0   197351    2344    0瓶    4685656.0  "
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "emaotai_0816[emaotai_0816['品牌']=='贵州茅台酒']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "品牌\n",
       "仁酒         4267356.0\n",
       "华茅酒         738166.0\n",
       "汉酱酒        6070950.0\n",
       "王茅酒         696507.0\n",
       "生肖纪念酒    100089478.0\n",
       "茅台王子酒      2890750.0\n",
       "茅台迎宾酒      1950995.0\n",
       "贵州大曲       9533199.0\n",
       "贵州茅台酒    562890185.0\n",
       "赖茅酒         821876.0\n",
       "Name: 销售额, dtype: float64"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "emaotai_0816.groupby('品牌').销售额.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "品牌\n",
       "仁酒         7987\n",
       "华茅酒         734\n",
       "汉酱酒        8628\n",
       "王茅酒         693\n",
       "生肖纪念酒     45722\n",
       "茅台王子酒      7693\n",
       "茅台迎宾酒      7667\n",
       "贵州大曲       8401\n",
       "贵州茅台酒    246029\n",
       "赖茅酒        2524\n",
       "Name: 已售出量, dtype: int64"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "emaotai_0816.groupby('品牌').已售出量.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x144854ee588>"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAW0AAAE8CAYAAAAL0+BwAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAHLpJREFUeJzt3XmY3VV9x/H3ByOEJWkSGAjKElmDgmzBKqjFWkVBayog\nagUEIRUULVD2XQFxrQUFCQrUWotWlE0FClECVNCwPVI1CBLqEmiAYgMCAvn2j3Nu5mYyM3eQ+S1n\n5vN6nnnumvl9c2fmc889v7MoIjAzszKs0nQBZmY2cg5tM7OCOLTNzAri0DYzK4hD28ysIA5tM7OC\nVBraklaXtEWVxzAzG08qCW1JkyVdBjwEHN3juRtLukHSvZLmS1q/iprMzMaCqlray4BzgCNG8NxT\ngX+PiM2Am4G/r6gmM7PiVRLaEfF4RFwPPNt9v6SjJP1M0s8lzc53P931lImk1rmZmQ1iQl0HkvSX\nwPbANsA04DZJVwAnAt+R9E5SYB9TV01mZqWpc/TI7sCuwH8BNwKrAesBewALgUOByfk5ZmY2iNpa\n2vlYn4iIc7rvlPRpYJOIeFzSScB5wLU11mVmVow6W9o3AftJWkvJ6/P9TwGvytd3BB6rsSYzs6JU\n0tKWNAm4A5gETJS0K3AwKbh/ATwJzAXmAwcB50qaAPwWmFNFTWZmY4G8nraZWTk8jd3MrCCj3j2y\nzjrrxIwZM0b725qZjWm33XbbwxHR1+t5ox7aM2bMYMGCBaP9bc3MxjRJD4zkee4eMTMriEPbzKwg\nDm0zs4I4tM3MCuLQNjMriEPbzKwgDm0zs4I4tM3MCuLQNjMrSJ3raZuZPS8zjv3uC/4ei87aYxQq\naQ+3tM3MCuLQNjMriEPbzKwgDm0zs4I4tM3MCuLQNjMriEPbzKwgDm0zs4I4tM3MCuLQNjMriEPb\nzKwgDm0zs4I4tM3MCuLQNjMriEPbzKwgDm0zs4I4tM3MCuLQNjMriEPbzKwgI9ojUtIi4Nl8c3FE\nvK6yiszMbEgj3tg3IjarshAzM+vN3SNmZgUZaWg/Kek+SbdI2m3gg5LmSFogacGSJUtGuUQzM+sY\nUWhHxFYRsSlwFPCvkqYMeHxuRMyKiFl9fX1V1GlmZjzP7pGIuBFYBMyoohgzMxtez9CWtKak9fP1\n7YH1gV9WXZiZma1sJKNH1gBukPQi4PfA+yLiiWrLMjOzwfQM7YhYAmxRQy1mZtaDh/yZmRXEoW1m\nVhCHtplZQRzaZmYFcWibmRXEoW1mVhCHtplZQRzaZmYFcWibmRXEoW1mVhCHtplZQRzaZmYFcWib\nmRXEoW1mVhCHtplZQRzaZmYFcWibmRXEoW1mVhCHtplZQRzaZmYFcWibmRXEoW1mVhCHtplZQRza\nZmYFcWibmRXEoW1mVhCHtplZQRzaZmYFGVFoS1pV0s8kfbnqgszMbGgjbWkfDyyqsA4zMxuBnqEt\naStgJ+Cb1ZdjZmbDGTa0JQk4G/hoj+fNkbRA0oIlS5aMZn1mZtalV0v7g8API+Le4Z4UEXMjYlZE\nzOrr6xu96szMbAUTejy+LzBJ0t7ANGBNSQsj4tPVl2ZmZgMNG9oRsXPnuqT3A691YJuZNcfjtM3M\nCtKre2S5iLgYuLiySszMrCe3tM3MCuLQNjMriEPbzKwgDm0zs4I4tM3MCuLQNjMriEPbzKwgDm0z\ns4I4tM3MCuLQNjMriEPbzKwgDm0zs4I4tM3MCuLQNjMriEPbzKwgDm0zs4I4tM3MCuLQNjMriEPb\nzKwgDm0zs4I4tM3MCuLQNjMriEPbzKwgDm0zs4I4tM3MCuLQNjMriEPbzKwgDm0zs4L0DG1Jq0j6\nD0n3SFooabc6CjMzs5WNpKUdwH4RsQXwUeCMaksyM7Oh9AztSBbnmxsDdw18jqQ5khZIWrBkyZLR\nrtHMzLIR9WlLOlrSI8DhwMcGPh4RcyNiVkTM6uvrG+0azcwsG1FoR8SnImJt4HjgGkmqtiwzMxvM\n8xo9EhHfBtYC1q6mHDMzG85IRo9sIml6vv4a4KmIeLjyyszMbCUTRvCcKcDVkl4EPATsU21JZmY2\nlJ6hHRG3A1vUUIuZmfXgGZFmZgVxaJuZFcShbWZWEIe2mVlBHNpmZgVxaJuZFcShbWZWEIe2mVlB\nHNpmZgVxaJuZFcShbWZWEIe2mVlBHNpmZgVxaJuZFcShbWZWEIe2mVlBHNpmZgVxaJuZFcShbWZW\nEIe2mVlBHNpmZgVxaJuZFcShbWZWEIe2mVlBHNpmZgVxaJuZFcShbWZWEIe2mVlBeoa2pImS5kq6\nR9IDkg6vozAzM1vZSFraawLXAFsCOwLHStqw0qrMzGxQPUM7Ih6JiEsjeRj4NTCl+zmS5khaIGnB\nkiVLqqrVzGzce1592pK2BiYCd3ffHxFzI2JWRMzq6+sbzfrMzKzLiENb0jrAvwAHRERUV5KZmQ1l\nRKEtaSpwFXB8RPyk2pLMzGwoIxk9Mhm4Ejg9Ir5ffUlmZjaUkbS0PwJsD3xe0r35a5OK6zIzs0FM\n6PWEiDgdOL2GWszMrAfPiDQzK4hD28ysIA5tM7OCOLTNzAri0DYzK4hD28ysIA5tM7OCOLTNzAri\n0DYzK4hD28ysIA5tM7OCOLTNzAri0DYzK4hD28ysIA5tM7OCOLTNzAri0DYzK4hD28ysIA5tM7OC\nOLTNzAri0DYzK4hD28ysIA5tM7OCOLTNzAri0DYzK4hD28ysICMObUmrS9qiymLMzGx4PUNb0mRJ\nlwEPAUdXX5KZmQ1lJC3tZcA5wBEV12JmZj30DO2IeDwirgeeraEeMzMbxoTR+CaS5gBzADbaaKPR\n+JY2zsw49rsv+HssOmuPUajErN1GZfRIRMyNiFkRMauvr280vqWZmQ3CQ/7MzAri0DYzK0jPPm1J\nk4A7gEnAREm7AgdHxA8qrs3MzAboGdoRsRTYrIZazMysB3ePmJkVxKFtZlYQh7aZWUEc2mZmBXFo\nm5kVxKFtZlYQh7aZWUEc2mZmBXFom5kVxKFtZlYQh7aZWUEc2mZmBXFom5kVxKFtZlYQh7aZWUEc\n2mZmBXFom5kVxKFtZlYQh7aZWUEc2mZmBXFom5kVxKFtZlYQh7aZWUEc2mZmBXFom5kVxKFtZlYQ\nh7aZWUEmNF2AmbXTjGO/+4K/x6Kz9hiFSqzbiFrakt4l6X5J90o6sOqizMxscD1b2pImAZ8FXg08\nB9wp6cqIWPKnHNDv3v38WpjZ8zWS7pHdgBsi4rcAkuYBbwQuqbIwsya04Y20DTXYitr0M1FEDP8E\n6XBgnYg4Id/+FLA4Iv6x6zlzgDn55pbAwhdY1zrAwy/we7xQbagB2lFHG2qAdtTRhhqgHXW0oQZo\nRx2jUcPGEdHX60kjaWmvCizrur2M1E2yXETMBeY+r/KGIWlBRMware9Xag1tqaMNNbSljjbU0JY6\n2lBDW+qos4aRnIhcDLy06/YGwK+rKcfMzIYzktC+FthN0rqSpgM75/vMzKxmPbtHIuJBSScAP8p3\nHRkRT1Rb1uh1tbwAbagB2lFHG2qAdtTRhhqgHXW0oQZoRx211dDzRKSZmbWHp7GbmRXEoW1mVhCH\ntplZQRzaZmYFaXSVP0mfi4gjJL0JWH2w50TEFWO9BtfhGtpeR65lXWDiUI9HxH9XfPzGX4s21NB0\nS3u7fPkJ0jTQ2aR1TT4J9OXL8VCD63ANba8D4FvAscBxpCHAneud21Vrw2vReA1Nh/ZL8lKvawEC\npgHfJK1t8hXgwXFSg+twDW2vA9IQ4UMj4hDgV53rnds1HL8Nr0XjNTS9CcIzpEVWngGWAJ+LiJsl\njbcaXIdraG0dSge7ENhM0oWksOpcJ9+uY8JH469FG2pouqU9BXhDvtwBeGqc1uA6XENr64g0A+84\n4AH6u0QeoL9r5LiaSmn8tWhDDU23tH8DfIG0wcKVwN9J+vOux+t4925DDa7DNbS9jtVILerVSI29\nznXy9Tq04bVovIamQ/upiLhP0lTgFNIPfxawkaQrgVeOkxpch2toex3Hklb4PC7XsGG+r86+iTa8\nFo3X0OjaI5LeTtpg4SJJUyLiMUmbAksi4v/GSw2uwzW0vY5cy40R8bp8fX5EvL7rsRVuV3T8xl+L\nNtTQWJ+2pMmkd6qFklYHrpU0gzR85mZJV0p6bwtq+Nsqa3AdrqHtdQyo6VxJ55FORJ7bfbvi4zb+\nWrShBmiwpS3pxcDLSR+zBKwZEZd0Pb41cGdEVNaF06khIu7K76ADa3gF8NqIOL+qGkZYx9bALi2o\no/LXwzW0r46u463H8JNrHqjw2I2/Fm2oAYCIaPQLuH2Yx+6o4fhzB7nvQmDLml+HvYEZ+fqfAXs3\n9PNoxeuRj3t8/sPo3J4KfA1YrYFaLm3o5/GK/Dq8Nd+emS+/kS/3AqbWWM95g9y3LvCZml+XU4G/\nbuDn0fjfR9ND/mD4Exl1fAyYCWl6qqSt8n07AmdI2qKG43ccCpwraRrpBPE0Sb+UdHm+vKemOlrx\nekhag9RqeSLfngFcAZwfEU/XcPxfSOr+yP+Sqo85hO1Ivw+/z7c7i+2/JLf8Pg78ocZ6dhzkvo9S\nY1erpDOBNwFXSzq5+6uGwzf+99GG0G56F4bJufthe6Czw/yjEbEX8MuaazkG+Cz9r8lvgJ/ky9/U\nVENbXo/9SW9in5d0OGlCwxeA90l6TQ3Hnwx8XVJnWFuTv6cP0v+z6DYbuKyON7EuKzSyJL0ReCfw\nsVoOLn0aWBt4MCL+CLwHWADcRvq0WrXG/z7aENpNmwq8Kl+fL2l/8h9o5M8+NdZxH/BXwOa5pnVJ\nv6B1avz1kLQxqZV9FakV8xTw78DlwNnUs7XTA8D5wAU1HGs4ATwCTMq3N5N0LbA1sAfpjazuegCQ\n9EHgTODtEfFYTce/HDgcWCPffiwivhcR3wXqqKHxv482hPZw3SN1jAF9ICIuJL3wnwLmAK+SNF/S\njyT9Sw01QNr1/n2kkNgPeBJ4FvhMTcfvaMPrcR7w95KOIp0sPw84CrgOuId6/jgj0loSz0n6BvCy\nrtESX5C0Z9UFSFof2CfffDJf3hcRbwbuBg6MiN9WXUeu5TBJHwL6JH1G0vWkcy+7RsS9ddQAEBE3\nkd7E1xzs4RpKaPzvo8khf8rDZmYP87QFddVDeoOYBPwxf30tIl4DbFPT8WcDu5M+cj0HrAosreuP\nchBNvh5/AP6atLbDsnzf6cB+EfEM9XZVHAKcQ2rt/mv+uhz4fA3H3hC4P1/vvA7L/+8RsWylf1Gd\nzusu0pKkawGb0t/irZSkbSV9CZb/v19cx3GHK4mG/j6anBE5A7iG9BHjP4d4Th3LPW4s6eB8/UjS\nx++PADvluq6vugBJE4CLST+P8+kPqy0kHVL18Qdo/PUAPgB8ldRXemC+72Bg33yCcp0aagAgIp4C\nbpL0fxFxc+d+SU/UcOwfS9o833xa0qrdj+fx0adExP/UUMuX8jEPiIgP5evvBn4gad+IuKvi498l\nabGkrwN/S3PZ1fjfR2Mt7Yi4n3Qm9hLSmeDzSfP51fVVh0eB+fn6iyPiO6QWxTGkP4gjqy4gIp4F\njiYNZ3sGOAO4g/QReLCPgVVqw+vxe1JoH0T/78HTpD7/O0n9/lXr9ft3fA01dHsc+CHwCkk3kvq0\nbyb179apu6V/Cakr7xJJL638wBGnATcBX6S/pT1F0u6S9iD1N1et8b+PRvu0I2JZRFwXEe8hzd9f\nG/iviPhK/rqwx7cYDUsjYiHws4g4pqu2R4HFknaooQZIM61+BbwMWC/ftzqwC2lCw5CTGkZZr9dj\n+zqKiIhLSV0knYB+itR/OJ16+rRvH3B7hRCPiG/XUEPHzsAJEbFzRKwdaSr5T0kNnt0l1fW7ASu/\nDneSNgT4Yh0Hj4hzgYeAmZJWAb4B7ETKj2/VUELjedH0glHL5Y9XlZ/cGcTd+fJKSWeTuilukXQa\naZTCxjXVcVJELJZ0Iunn8rvcR9aZiXVmTXUsBeh8BM5uyZcXAJcCdY3XvogU0g9ExB8lzSG17A4i\nfSytzID/P0ClH/+HcSup/3hg3/H9EfGspJPy43UtEfq9gXdExFclzZS0Sk397B8j/Z5OiIhTazhe\nt5/myysk7Ud6E5sp6XWkvJjNym/4o6rRBaPaQGl9k2mkQNoBODsidlLX4jg11fEt0ieNW4BvRsQd\nXY8dCmwfEQcP9e9HsY7bI2KHrttXRcTbum7fERGVtrZzC2q5ThBIOog8zC0iKu07lLR5RAw57lbS\nuRFxaJU15OPsRv8nr45ngHkR8ZCkzwNHVB2Wkjbq9Zyofo/IuRExZ8B9FwKfzK3fykmaS3oD34v+\ncdoizaPYm7T0xiVD/PNR0ZqWdlMi4uuSrgIuiYgfSXqy5z+qxkuBN5M+6h0iaTrpRMeqwGHAaxus\nq1sd7/KPkPr0BWwn6S0RcWtEfDmPUf4Og8/MG03fIL2JAyu/eZHOv9ThBODLrNgtMYP0ifCtpBon\nkEYwVOmMfNn98++uKUifgqq0fDYicEFE/Jz+2YjHR0Qds4Y3I01424E0JPfNwBO5tolVBzY4tDst\niIuAU/OQoskNlRIRsRSYB8yTtAnpZNw00jokjzRVVwPHvDsi/hKWLwd66/JiIv5bUh3TtgeeiKz8\nRNsQFBFfXeGO1IfdedOqOqwBiIh987HXIoXzbNJ6KM/Vcfxs4GzEt5BnI0q17fc1k/Qm+l7SSdG7\nSeebXg28XNIaEVHp7+e4D23gtHy5M2kG4iWS9gHWlvQugIj4Zp0FKS0BuQ9p2N/vgI3o73uv4fA6\nunMdWHfA7TrEENeHu6/KGuo65gryUNCHJc0b/GEdT//46brsSBrJM7vmwIYWzEYE3k5aIOop0qed\njhtJs1M/TvqEXJlxH9oRcQCApA/ku+4mvWuuBqxfYymS9FlgK9Lkmq8Bu5Ja/vMkLYyI+2qqpbtV\n/9yA23XofnNQ/tTRMZU0E6/yGlrw5nUc8MWIuG5AYaeS+nGfzN1FlYdnHmbYmVwDsH9X41ak3Kx0\nEwTybERJ7yPNRrwB2FbSfNIQwHs7nwgqtAlwFWmU19J8372kIZnPUMOu9OM6tPOojD1zP9QVwNF5\n6vKtkvaKiH+qsZxFpHfwe2PFBYAek/QPpHHsdYxP7kzfBkDShwberqGGX3Rd/x5wEv2B8UfSlPY6\nNP3mdTPwDq28wuNS0kzNz5HGClc+YiP6d6xZhdTa3BPYv8YWbrfBZiPOlXRnDcfekNQtciBpcTcB\n/0Caxfv+PASyUuM6tElBsIukw0hLX6quUQGDOAt4R0ScKWlqRPyvpF2BhRExT9I2kibkiTh1qnMP\nQAAi4mBJ/wZcFRGfgP7RGvny2nrKaPzN6z+BdwMnsuLPYRX6N9WdUkMd3d5COgl3cgOB3fhsROAA\n0pvWpsCHST+X15OGAv6zJCLinVUWMK5DOwfgYZI+Qlq3+DBq+Kg5kKRJpEWS3itpCnCNpN1JJ1xO\nlrQm8B811TYwpG/u8fjoHjydRxDpj+NESdfl69vmadzrSZocNe+PSDNvXk8pLUv7uoi4Os86nED+\n1CHpSOqZUIKka0iTvTqvwxslPU5aauLiqHDXmi6d2YjvJc9GzA2uY0jrrNexNOvFpJb2afSP6lkD\nuBa4a2BXVhXGdWh3RMTZkj4GTIn+BZruGO7fjLI/kFZsWyTpAOCoiHiYdIb8H5V2ft61ppbNG7tv\nRMSHBzx+RcXHv4700fNS4MekEzwnkyY5rUfqP9ySNOyqSo2+eQFI2gb4Cv1L0V5LmmzTOf4m1DQh\nLSJ2yzXtTppcdTXpJPnrgfMlXR8Rn664jKURsVDSSrMRldYl2SEiKp3YQlpK4VFSYPfl+86IiPmS\nTpT02zwUsTLjfnKNtVNuVX+YNFlhnqS3kVpZryUtgF/trDNpWp6aPNTjp0XEKRXXsDnwZET8Jt++\noHuClaQtSa3Mg2qaiYjSzkofIs0nOLnTh5tHXF0REZXNc5D0xYEzVSWdGRHH56GAG0daV3tMc2ib\n9ZBHa9weEVV/yuhVx2nAbU3UkUfwdHZV+imp1b9LfvhnpJFON0TElRXW0PiszDZwaFvrSPo74J9J\nQ942H/BwALdExDk11XIm8BfAG4BjVygkopYtttpQh6QdgVeSJtZcRlrr/p9Iq1M+Qhr5tFOVLX6t\nuMHAYDMzIyKqnpXZuDbsXGM20M9Jw9neRAruTbsuTyKNGKicmt+PsE11BOncy7P0B+ajETGPNFv0\n+1V30UTEvnkc9iGkNXqmAwd07h8PgQ0ObWuhiJhP+vitPCrh6a7LXwF1jRxpej/CNtWxJ+kk9UtJ\ns4chjWB5D+ncQ517aTY5K7NxHj1iraP+JS8H7lDT+Rj89jrqiIib8mSSpvYjbFMdT5KC8rl82TGR\nNGb8FaTNkCvTklmZjXNoWxsNu/9fRPyuyoNL2hY4JCI+GBHL8szZ2rWljuz7pBXuZpK6ZSCF5EVK\nywp/j0HW2h5NLZuV2Rh3j1jr5JmHV5P2ymzi+HeRdiH5el49rpHGTVvq6DKN1Kp+Ub49PU+GeiXw\ngKSX1VRHk7MyG9f0L4HZSiRtQFoxrTNeW/mys16M8gm5ykTEaUqbT6y0HyHpo3gd+xG2pg7gYdIK\ne/eRFjGLXNNUUr/6T4A/p3/3+FHXklmZjfOQP2sdSceQhvydBLx8kKcE8LaoeN3iXMsppJEra+R6\n+otIG83Woi115FreTdrL9add921MOlH8YA3HH2xW5oeBOmZlNi8i/OWvVn4Bf9V1fXLX9W/XcOy5\n+VLAEaRugQuBmTW/Bq2oo01fpG6ak0hLKmzXdf8+wOpN11f1l/u0rc26NzPuXohneg3HnpkvPwtc\nHWm53B2B0yXVtbFxm+ponKRNJH2HtO7HBOCTwJslHZ2XOdiJepYvbpRD29pMQ1yvQ/fWVp/L9z0a\nEXsBQ274O4braIOppNb1VNKiTQDvIk00+jVptuiYX3vEoW1t1mvbsSq1YWurNtXRBo3PymwDjx6x\n1pF0EemPcoakC0mt7O7rdWjD1lZtqqMN9iQth9qZlXkb/bMyO9Pbxzy3tK2NvkRaQ/rhfP38Adfr\nNNjWVq8BthmndTRpJLMyxzyHtrXRHRFxC/B4RPx4kOt1GGxrq7tIW1ttTT1bW7Wpjjb4PmnXmAcZ\nMCsTmE0aEjnmObStjfaUdCuwatd9dZ+I7GxtBXlrK1KXzTHAKRFx5Diroy3aMiuzMQ5ta52I+DfS\nhrYLJH07b7fW3aKsI8CXRsRCYKWtrUhTy3eooYY21dEGw83KXJP+WZljmk9EWitFxP3AQZLeAXwg\nIroX/q96H0BIu7MQK25v1emamUvas7IObamjcZGmqR8Ay2dlLo2I5ec4JC1kxb7uMcnT2M3MCuLu\nETOzgji0zcwK4tC2cU/SYDvCmLWS+7RtzJD0QdJKeP8z4KGNgDmkdZ/fku+7ujPmO88ufEOMw/0G\nrTwePWJjzZkRcXH3HZJOHeyJki4D1gI2AX4gaTpwYETcVHWRZn8qd4/YeHcWcAdwDvCDhmsx68kt\nbRtLngGOlnTQgPunk6Y/A7wfWESahPF0fmwaqcU9qZYqzV4Ah7aNGZE2BP7KUI9LejVpL8FT8+3L\ngCmk2XVrkvYfNGs1n4i0MSEvXXoy6STkuqRdbzYgbUH1e2BD0gqBhwPLgP2BxcAJwBPADNJU+cuj\na+9Ds7ZxaNuYkEN7QkRcLOn9+e4NgJsi4oeSTiTtcLItqVvkF8D6wC7AUcAFeTcYs1Zz94iNJS+W\nNJG0OcAzgzy+Fak/e33graS9FiFtUbWFpJuAxRGxdw21mv1J3NK2MSG3tE8krbU8nTQqZAPgb4D/\nJXV/rAZsR9pX8J6IuD7/27VIfd1uaVvrObRt3JCkcbivoo0xDm0zs4J4co2ZWUEc2mZmBXFom5kV\nxKFtZlYQh7aZWUEc2mZmBfl/VnJzzMLHozgAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x144855b99b0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "emaotai_0816.groupby('品牌').销售额.sum().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1448566ba90>"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYoAAAE0CAYAAAAyvnQVAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3XucHFWZ//HPV0JMwPBLgGggCQZBRMEbibte8IYioLgi\nqFwWgSCyIIo/cEFEEHAR0VXxhkogEFAkighIooiCirCiBIEX4Apyi0kMbiCrRJMoMM/+cU5nKs3k\nzDAzXV1mvu/Xa15d/XR119M9M/3UqapzjiICMzOzdXlatxMwM7Nmc6EwM7MiFwozMytyoTAzsyIX\nCjMzK3KhMDOzIhcKMzMrcqEwM7MiFwozMysa1e0EhsPmm28e06ZN63YaZmb/UG655ZaHI2Jif+ut\nF4Vi2rRpLFiwoNtpmJn9Q5G0cCDr+dCTmZkVuVCYmVlRv4VC0hhJsyTdI2mhpGNy/DFJ9+afuZX1\nz5S0WNIdkqbn2ChJcyQtkXSTpK1zfJykeTl+jaTNcnyypBskLZI0V9KYzrx9MzPrz0BaFBsDPwSe\nB0wHTpA0FVgSEdvmn/0AJO0C7AxMA44FZufXOAgYA0zJsbNy/DjgroiYDNwMnJzjnwQujoipwOPA\nEUN5k2ZmNnj9FoqIeCQiLovkYWARMH4dq+8NzImIxyPiR8BESZNy/LxIk19cDLyxsv65eflCYPe8\nvCcwJy9fVImbmVnNntI5Ckk7kloGdwKbSbpP0k8kzcirTAWqZ9GXAFtU4xGxElgpaQKphdFafzGw\nRY6viohV1XgfuRwuaYGkBcuWLXsqb8PMzJ6CARcKSZsDXwdm5tbFuIjYBvgKcHlebTTQU3laD/BE\nP/EY4LpriYhZETEjImZMnNjvZcBmZjZIAyoUeS9/HnBiRNxcfSwiLgXGShoPLAUmVx7ektQiWBOX\nNBbYICIeBR7K60BqXSwClgHjJY1ui5uZWRcM5KqnTYCrgNMj4gc5tnkuDEjaA3gkIv4EzAcOlrSB\npF2BeyJieY7PzC95IHBlXp4PHJqXZwKXRkQP8FPggBw/BLh0KG/SzMwGbyA9s48GXgp8XtLnc2wf\n4ApJPaTWwrty/HLgtcD9wCP0ftmfDVwgaVF+bN8cPwW4RNJi4JbK+kfn+OnA1cAlg3t7ZmZP3bQT\n5g/p+Q+e+ZZhyqQZ+i0UEXE6cHofD23dx7o9pC/5o9viq4H9+1h/ObBbH/EHgJf3l5uZmXWee2ab\nmVmRC4WZmRW5UJiZWZELhZmZFblQmJlZkQuFmZkVuVCYmVmRC4WZmRW5UJiZWZELhZmZFblQmJlZ\nkQuFmZkVuVCYmVmRC4WZmRW5UJiZWZELhZmZFblQmJlZkQuFmZkVuVCYmVmRC4WZmRW5UJiZWZEL\nhZmZFblQmJlZkQuFmZkVuVCYmVmRC4WZmRW5UJiZWZELhZmZFblQmJlZkQuFmZkVuVCYmVmRC4WZ\nmRW5UJiZWVG/hULSGEmzJN0jaaGkY3L8g5J+L+luSXtU1j9T0mJJd0ianmOjJM2RtETSTZK2zvFx\nkubl+DWSNsvxyZJukLRI0lxJYzrz9s3MrD8DaVFsDPwQeB4wHThB0muBo4AdgLcDsyVtKGkXYGdg\nGnAsMDu/xkHAGGBKjp2V48cBd0XEZOBm4OQc/yRwcURMBR4HjhjCezQzsyHot1BExCMRcVkkDwOL\ngNcA346IFRHxG+BBUhHZG5gTEY9HxI+AiZIm5fh5ERHAxcAb88vvDZybly8Eds/LewJz8vJFlbiZ\nmdXsKZ2jkLQjqWWwObCw8tBiYAtgalt8SXs8IlYCKyVNILUwFlZfI8dXRcSqttduz+VwSQskLVi2\nbNlTeRtmZvYUDLhQSNoc+DowExgN9FQe7gGeGGQ8BrjuWiJiVkTMiIgZEydOHOjbMDOzp2hAhSLv\n5c8DToyIm4GlwOTKKlNIh6Ta41uSWgRr4pLGAhtExKPAQ3md6mssA8ZLGt0WNzOzLhjIVU+bAFcB\np0fED3J4PrCfpI0kvQDYFLgtxw+WtIGkXYF7ImJ5js/Mzz0QuLLyOofm5ZnApRHRA/wUOCDHDwEu\nHfQ7NDOzIRlIi+Jo4KXA5yXdK+le4H+BbwB3AZcB780nqi/PsfuBTwHvz69xNjBG0iJSoTgpx08B\nXiFpMbAjvVdDHQ0ckeOrgUuG9C7NzGzQlL7f/7HNmDEjFixY0O00zGw9Me2E+UN6/oNnvmWYMuks\nSbdExIz+1nPPbDMzK3KhMDOzIhcKMzMrcqEwM7MiFwozMytyoTAzsyIXCjMzK3KhMDOzIhcKMzMr\ncqEwM7MiFwozMytyoTAzsyIXCjMzK3KhMDOzIhcKMzMrcqEwM7MiFwozMytyoTAzsyIXCjMzK3Kh\nMDOzIhcKMzMrcqEwM7MiFwozMytyoTAzsyIXCjMzK3KhMDOzIhcKMzMrcqEwM7MiFwozMytyoTAz\nsyIXCjMzK3KhMDOzogEXCkljJW3XyWTMzKx5+i0UkjaRdAXwR+D4SvwxSffmn7mV+JmSFku6Q9L0\nHBslaY6kJZJukrR1jo+TNC/Hr5G0WY5PlnSDpEWS5koaM9xv3MzMBmYgLYoe4EvAsW3xJRGxbf7Z\nD0DSLsDOwLS8/uy87kHAGGBKjp2V48cBd0XEZOBm4OQc/yRwcURMBR4Hjnjqb83MzIZDv4UiIv4S\nEdeSvrD7szcwJyIej4gfARMlTcrx8yIigIuBN1bWPzcvXwjsnpf3BObk5YsqcTMzq9lQTmZvJuk+\nST+RNCPHpgILK+ssAbaoxiNiJbBS0gRSC6O1/mJgixxfFRGrqvEh5GlmZkMwarBPjIhxAJLeCVxO\nKgajSYeqWnqAJ/qJxwDXXYukw4HDAbbaaqvBvg0zM+vHkC+PjYhLgbGSxgNLgcmVh7cktQjWxCWN\nBTaIiEeBh/I6kFoXi4BlwHhJo9vi7dudFREzImLGxIkTh/o2zMxsHQZVKCRtngsDkvYAHomIPwHz\ngYMlbSBpV+CeiFie4zPz0w8ErszL84FD8/JM4NKI6AF+ChyQ44cAlw4mTzMzG7p+Dz1JGgfcCowD\nxkh6HfAF4FhJPaTWwrvy6pcDrwXuBx6h98v+bOACSYvyY/vm+CnAJZIWA7dU1j86x08HrgYuGcJ7\nNDOzIei3UETECmDbPh76Uh/r9pC+5I9ui68G9u9j/eXAbn3EHwBe3l9uZmbWeR7Cw8zMilwozMys\nyIXCzMyKXCjMzKzIhcLMzIpcKMzMrMiFwszMilwozMysyIXCzMyKXCjMzKzIhcLMzIpcKMzMrMiF\nwszMilwozMysyIXCzMyKXCjMzKzIhcLMzIpcKMzMrMiFwszMilwozMysyIXCzMyKXCjMzKzIhcLM\nzIpcKMzMrMiFwszMilwozMysyIXCzMyKXCjMzKzIhcLMzIpcKMzMrMiFwszMilwozMysaMCFQtJY\nSdt1MhkzM2uefguFpE0kXQH8ETi+Ev+gpN9LulvSHpX4mZIWS7pD0vQcGyVpjqQlkm6StHWOj5M0\nL8evkbRZjk+WdIOkRZLmShoz3G/czMwGZiAtih7gS8CxrYCkbYCjgB2AtwOzJW0oaRdgZ2BaXn92\nfspBwBhgSo6dlePHAXdFxGTgZuDkHP8kcHFETAUeB44Y5PszM7Mh6rdQRMRfIuJa0hd2y9uBb0fE\nioj4DfAgMB3YG5gTEY9HxI+AiZIm5fh5ERHAxcAb8+vsDZybly8Eds/LewJz8vJFlbiZmdVssCez\npwILK/cXA1v0EV/SHo+IlcBKSRNILYyF1dfI8VURsarttc3MrAsGWyhGkw5JtfQATwwyHgNcdy2S\nDpe0QNKCZcuWDfJtmJlZfwZbKJYCkyv3pwCL+ohvSWoRrIlLGgtsEBGPAg/ldaqvsQwYL2l0W3wt\nETErImZExIyJEycO8m2YmVl/Blso5gP7SdpI0guATYHbcvxgSRtI2hW4JyKW5/jM/NwDgSsrr3No\nXp4JXBoRPcBPgQNy/BDg0kHmaWZmQzSqvxUkjQNuBcYBYyS9Dngv8A3gLmA1cFhEhKTLgdcC9wOP\n0PtlfzZwgaRF+bF9c/wU4BJJi4FbKusfneOnA1cDlwzxfZqZ2SD1WygiYgWwbR8P/QQ4o23dHtKX\n/NFt8dXA/n289nJgtz7iDwAv7y83MzPrPA/hYWZmRS4UZmZW5EJhZmZFLhRmZlbkQmFmZkUuFGZm\nVuRCYWZmRS4UZmZW5EJhZmZFLhRmZlbkQmFmZkUuFGZmVuRCYWZmRS4UZmZW5EJhZmZFLhRmZlbk\nQmFmZkUuFGZmVuRCYWZmRS4UZmZW5EJhZmZFLhRmZlbkQmFmZkUuFGZmVuRCYWZmRS4UZmZW5EJh\nZmZFLhRmZlbkQmFmZkUuFGZmVuRCYWZmRS4UZmZW5EJhZmZFLhRmZlY0pEIh6UFJ9+afn+fYByX9\nXtLdkvaorHumpMWS7pA0PcdGSZojaYmkmyRtnePjJM3L8WskbTaUPM3MbPCG3KKIiG3zz6slbQMc\nBewAvB2YLWlDSbsAOwPTgGOB2fnpBwFjgCk5dlaOHwfcFRGTgZuBk4eap5mZDc5wH3p6O/DtiFgR\nEb8BHgSmA3sDcyLi8Yj4ETBR0qQcPy8iArgYeGN+nb2Bc/PyhcDuw5ynmZkN0FALxSpJ9+XDRrsB\nU4GFlccXA1v0EV/SHo+IlcBKSRNILYyFba+xFkmHS1ogacGyZcuG+DbMzGxdhlQoIuL5EbEN6VDR\nxcBooKeySg/wxCDj0RZr3/asiJgRETMmTpw4lLdhZmYFw3LoKSJ+TjrMtBSYXHloCrCoj/iWpJbC\nmrikscAGEfEo8FBep/oaZmbWBaMG+0RJGwObRMRSSS8lHR66FjhX0mdIJ643BW4D5gPvk3QxsAtw\nT0QslzQfmAlcDxwIXJlffj5wKHBqfvzSweZpVjLthPlDev6DZ75lmDIxa65BFwpgI+BnkjYA/gwc\nGBE3SvoGcBewGjgsIkLS5cBrgfuBR4AD8mucDVwgaVF+bN8cPwW4RNJi4JbK+mZmVrNBF4qIWAZs\n10f8DOCMtlgPcHT+qcZXA/v38RrLgd0Gm5uZmQ0f98w2M7MiFwozMytyoTAzsyIXCjMzK3KhMDOz\nIhcKMzMrcqEwM7MiFwozMytyoTAzsyIXCjMzK3KhMDOzIhcKMzMrcqEwM7MiFwozMytyoTAzsyIX\nCjMzK3KhMDOzIhcKMzMrcqEwM7MiFwozMytyoTAzsyIXCjMzK3KhMDOzIhcKMzMrcqEwM7MiFwoz\nMytyoTAzsyIXCjMzK3KhMDOzolHdTqAu006YP+TXePDMtwxDJt3nz6JZmvL7GGoeTchhuPKwtblF\nYWZmRS4UZmZW5EJhZmZFjS0Ukt4l6QFJ90o6tNv5mJmNVI08mS1pHPBZ4OXAE8Btkq6KiGXdzczM\nrB5NOrHfyEIB7Ab8LCKWAEi6DngDMLerWQ1Rk37x3ebPwuwfhyKi2zk8iaRjgM0j4qP5/qeBpRFx\nVmWdw4HD893nAXcPcbObAw8P8TWGQxPyaEIO0Iw8mpADNCOPJuQAzcijCTnA0PN4dkRM7G+lprYo\nRgM9lfs9pENQa0TELGDWcG1Q0oKImDFcr/ePnEcTcmhKHk3IoSl5NCGHpuTRhBzqzKOpJ7OXApMr\n96cAi7qUi5nZiNbUQnENsJukZ0qaBLwyx8zMrGaNPPQUEQ9J+ijwixz6UET8tcObHbbDWEPUhDya\nkAM0I48m5ADNyKMJOUAz8mhCDlBTHo08mW1mZs3R1ENPZmbWEC4UZmZW5EJhZmZFjTyZ3UmSPhcR\nx0raFRjb1zoR8b2RkEcTcmhKHk3IoSl5NCGHSi7PBMas6/GI+H0NOXT98+h2DiOxRfGSfPtJUq/G\nvUjDg3wKmJhvR0oeTcihKXk0IYem5NGEHFq+A5wAfIR0FWRruXW/Dk34PLqaw0gsFFvm0WifAQjY\nFPg2aYiQ2cBDIyiPJuTQlDyakENT8mhCDi2KiPdFxJHA/a3l1v2acmjC59HVHEbcoSfgMdLYKI8B\ny4DPRcSNkkZiHk3IoSl5NCGHpuTR9RyUNnY+sK2k80lfjq1l8v26ru3v+ufR7RxGYotiPPD6fLsT\nsHoE59GEHJqSRxNyaEoeXc8hUgevjwAL6T3ctJDew04fqTGdrn8e3c5hJLYoFgNfJs11cRXwb5L+\nufJ4XXspTcijCTk0JY8m5NCUPJqQA8DTSS2Hp5N2alvL5OW6NOHz6GoOI7FQrI6I+yRNAE4h/cHN\nALaSdBXwohGURxNyaEoeTcihKXk0IQdILYkppNaDgKk5VvfxwCZ8Hl3NYcQN4SHpraS5Li6QND4i\n/iRpG2BZRDw6kvJoQg5NyaMJOTQljybkUMnl5xHx6rx8fUS8pvLYWvc7mEPXP49u5zCizlFI2oRU\nje+WNBa4RtI00mVmN0q6StIBDcnjX9f3HJqSRxNyaEoeTcihj5y+IumrpJPZX6ner2HbXf88GpHD\nSGpRSNoQeAGpCStg44iYW3l8R+C2iOjoIblWHhFxe95TaM9jB2DniDiniznsCLyqkzkMMI8mfBYd\nz6EpeTQhh7Z8nkW5w93CDm+/659HE3IgIkbcD/DrwmO31pTDrD5i5wPPq/FzeCcwLS//P+CdXfp9\ndP2zqGz3xPyP2Lo/AfgG8PQufTaXdWGbO+TPYY98f/t8+618+w5gQo35fLWP2DOBz3ThszkV+Jcu\nbLer/yMj6tBTRelkWF1NrO0hdc2X9Pwcmw58QtJ2NeXwPuArkjYlXdiwqaTfSboy395TUx5N+CyQ\ntBFpz+yv+f404HvAORHxt5py+K2k6iGVLevYbpuXkP4e/pzvt+Y82DLv3f4HsLLGfKb3EfsgNR86\nl3QGsCtwtaSPVX9q2HxX/0dGaqFowvG2TfLhnZcCZ+XY8oh4B/C7GvP4MPBZej+TxcDN+XZxTTk0\n5bM4mFQ4Py/pGFIHpy8DB0p6RU05bAJ8U1LrMtBu/a0+RO/vomov4Iq6Cme21o6dpDcAewMfry0B\n6T+BzYCHIuLvwP7AAuAWUsu807r6PzJSC0UTTAD+KS9fL+lg8pdC5HZlTTncB7wReG7O55mkf4g6\ndf2zkPRsUmtiHmlPbTVwKXAl8EXqm9FsIXAOcG5N2+tLAI8A4/L9bSVdA+wIvIVUPOvOBwBJRwBn\nAG+NiD/VmMOVwDHARvn+nyLi+xExH6gjj67+j4zUQlE69FTXNdoLI+J80i/708DhwD9Jul7SLyR9\nvYYclgIHkr6UDgJWAY8Dn6lh21VN+Cy+Cvx/SceRLvL4KnAc8GPgHur5MoD0fz8beELSt4CtK1f6\nfFnSPp3cuKQtgH3z3VX59r6IeBNwJ3BoRCzpZA6VXD4g6ShgoqTPSLqWdC7tdRFxbx05tETEDaSd\nh437eriGFLr6PzKiCoWSsaTm87osqCufTKQ9t7/nn29ExCuAF9aw7b2AN5Oask8Ao4EVdX0R9KGb\nn8VK4F9I4+j05NjpwEER8Rj1HwI6EvgSac/+4vxzJfD5Dm93KvBAXm59Dmvee0T0POkZndP63EUa\nWvsZwDb07tV3nKQXS/oarHnvG9a17XWlRBf+R0Zaz+xpwA9JTbf/Wsc6dQ1d/GxJ783LHyId3jga\neFnO7dpOblzSKGAO6W/gHHq/ILeTdGQnt92Hrn4W2XuAi0jHvg/NsfcC784nuTevIYc1ImI1cIOk\nRyPixlZc0l87vN1fSXpuvvs3SaOrj+f+C6dExP90Mo+cy9fyNmdGxFF5eT/gJ5LeHRG315DD7ZKW\nSvom8K907zuzq/8jI6pFEREPkK4emEu6euEc0tgpqvzUZTlwfV7eMCIuJ+09fZj0j/ihTm48Ih4H\njidd+vkY8AngVtLhhb6a153U1c8CICL+TCoUh9H7d/A30jmc20jncerQ39/gibVkkfwF+Cmwg6Sf\nk85R3Eg6Vl+naotmLukw6VxJk2vZeMRpwA3A2fS2KMZLerOkt5DOH3RaV/9HRlShgNR8jIgfR8T+\npLFSNgPuiojZ+ef8fl5iuKyIiLuB30TEhyv5LQeWStqphhxOIY3pvzXwrBwbC7yK1MlpnR2dhll/\nn8VL60giIi4jHX5qFYXVpGPBk6jvHMWv2+6vVTgi4rs15fFK4KMR8cqI2CzSMBp3kHay3iyprr8N\nePJncBtpAp+z60ogIr4C/BHYXtLTgG8BLyN9h3ynhhS6+n0x0g49rSU3XTt6crDgznx7laQvkg4D\n3STpNNIVNs+uIYeTI2KppJNIfwt/yMc7W71Bz6ghB4AVAK3DC9lN+fZc4DKgrv4UF5AKw8KI+Luk\nw0l7sIeRmvsd1fYZAHT88Eoffkk6H9B+LuCBiHhc0sn58bqGuv5+eyAiLpK0vaSn1Xje5OOkv9VR\nEXFqTdtsuSPffk/SQaTiub2kV5O+L/biyTsZw2ZEDeHRJEpjSm1K+iLcCfhiRLxMlUHQasjhO6QW\n1U3AtyPi1spj7wNeGhHvXdfzhzGPX0fETpX78yJiz8r9WyOio62KvJe4RuvLR9Jh5EtCI6Lj50ok\nPTci1nldvKSvRMT7OpzDbvS2MFseA66LiD9K+jxwbKe/oCVt1d86Uc+c2bMi4vC22PnAp/JefsdJ\nmkXaaXgHvf0oROrr9E7S0ENz1/H0IRvRLYpuiohvSpoHzI2IX0ha1e+Tht9k4E2kJvSRkiaRTpSN\nBj4A7NyFnFp5VdWxN/MI6RyNgJdI2j0ifhkR5+U+BJfTdw/h4fYt0o4D8OSiSTqn1mkfBc5j7UM+\n00it3j1yfqNIV9100ifybfX3X80pSK29TlvTKxo4NyL+m95e0SdGRB0jGGxL6gi7E+kS9jcBf825\njelkkQAXiq7Je0sXAKfmy+826UIaERErgOuA6yQ9h3RCd1PSuE+PdCEn6E5v5DsjYhdYM7T1L9ck\nE/F7SXUNWdF+MruWE7btOUTERWsF0jmJVqHsdIEAICLenbf9DFJB2Is0/tQTdWy/or1X9O7kXtFS\nbfOhbk8q3geQTqzfSTqH+HLgBZI2ioiO/Y26UHTPafn2laTe0HMl7QtsJuldABHx7bqSURrKeF/S\nJbJ/ALai9zxKDZvX8a1l4Jlt9+sQ61guxTqdR53bBdZcNv2wpOv6flgn0tu/oS7TSVeg7dWFIgEN\nGDkAeCtpEMDVpJZdy89JPeX/g3Q0oCNcKLokImYCSHpPDt1J2jt4OrBFTWlI0meB55M63H0DeB2p\ndXOdpLsj4r6acqm2Xp5ou1+HakFSbl21TCD1CK4ljy4XzY8AZ0fEj9uSOpV0TH5VPhTX8S/sfElu\nq8MdwMGVHXiRvqc7PnERuVe0pANJvaJ/BrxY0vWky2XvbbV+Oug5wDzSFYorcuxe0iXMj5GuXuwY\nF4ouyFcU7ZOPK34POD4P2/BLSe+IiC/UlMqDpL2Ue2PtQd7+JOnfSf1M6ug/0Bq2AgBJR7XfryGH\n31aWvw+cTO+X1N9Jw3nUpZtF80bgbXryyMErSL3FP0e6jr/jVxpF78x2TyPtUe8DHFzjXny7vnpF\nz5J0Ww3bnko65HQoaRBPAf9OGlHgkHzJcMe4UHRHAK+S9AHSUM6q42qWPpwJvC0izpA0ISL+V9Lr\ngLsj4jpJL5Q0KnfOq1PdcyITEe+VdAkwLyI+Cb1XGOXba+pLpatF87+A/YCTWPv38DRSaxdgfIdz\naLc76STux7pUJJowcsBMUrHcBng/6XfzGtJlsxdKIiL27tTGXSi6IH/xfkDS0aSx/z9ADU35Kknj\nSAPhHSBpPPBDSW8mnbD7mKSNgR/VlFd7Ybixn8eHd+PpnJBI/4wnSfpxXn5xHsLiWZI2iZrni26l\nV+fGImK10hDrr46Iq3Pv51Hk1pWkD1FPBzMk/ZDUAbT1GbxB0l9Iw+zMiQ7PblfR6hV9ALlXdN7J\n+zBprpI6hhmfQ2pRnEbvFWkbAdcAt7cfKhxuLhRdFBFflPRxYHz0DsR3a+k5w2glaSTQByXNBI6L\niIdJV3WcJWkCaZTOOvbg3lC9ExHvb3v8ex3e/o9JTfrLgF+RThB+jNTp8VmkY8HPI12e2GndLpov\nBGbTO6z6NaQOeK1tP4eaOqlGxG45pzeTOlxeTbrQ4jXAOZKujYj/rCGVFRFxt6Qn9YpWGgdqp4jo\nWGe37D5SwToPmJhjn4iI6yWdJGlJvmy3I9zhzizLrYf3kzovXSdpT9Ke5M6kCWs6/WWApE3zsAzr\nevy0iDilg9t/LrAqIhbn++dWO11Keh5pT/qwunpEK83AeBSpv8/HWsfj81WC34uIjvZBknR2e495\nSWdExIn5stlnR5qXYr3lQmHWUPlKo19HRKdbVKUcTgNu6UYO+cqz1uyLd5BaN6/KD/+GdIXezyLi\nqg7n0Yge4t3kQmEGSPo34ELS5aHPbXs4gJsi4ks15nMG8Frg9cAJayUTUcsUoN3OQdJ04EWkznZX\nkOaK+QJp1ONHSFfsvayGoUSqkwL11Us8IqKOHuJdM+JGjzVbh/8mXfq5K6lYbFO5PZl0lUst1P35\nmRuRA+lLeSVpyIrWF/TyiLiO1GP9BzVdpvvu3E/iSNK4aJOAma34+l4kwIXCDICIuJ50aEP5apq/\nVW7vB+q84qnb8zM3JYd9SBc6TCaNYADpyqv9SeeS6p5XvNs9xLvGVz2ZAeodurl9JrvW4YW31pVL\nRNyQO5l1a37mRuRAmrP7b6RLtKsdQseQ+nTsAHT8EtkG9RDvGhcKs6Q4F3JE/KHTCUh6MXBkRBwR\nET25B3+tmpBDxQ9Io6ZuTzrkBelL+QKlIfK/Tx9zVQy3BvYQr50PPZkBuffz1aS5w7uVw+2k2cq+\nmUclrX1Hrgk5tNmU1HrYIN+flDtIvghYKGnrGnPpdg/xrun2H4FZI0iaQhqFs9WfQvm2NTaX8knd\njoqI05QmjXrS/Mykwxwdn5+5CTlkD5NGbb2PNFBl5JwmkM6T3Az8M/BAJ5NoUA/xrvHlsWaApA+T\nLo89GXhBH6sEsGd0cMz/tnxOIV11tVHOqTeRiNP6fNJ6mEMll/1Ic9vfUYk9m3SxwUM15dBXD/H3\nA3X1EO81xKXjAAADk0lEQVQatyjMgIj4FICky1u9cKvjO0n6bh1FQr3TbrbmZ96QNJTIpyPit8Un\nr0c5tIs+ZnDrwp78TaQrnz5NOvw0D5gnaV9JYzvdQ7ybfI7CbG1nVJarA61Nqmn72+fbzwJXRxr+\nfTpwuqTtRlAOjSHpOZIuJ42zNAr4FPAmScfnYV5eRj3D8XeNC4XZ2rSO5bpUp938XI4tj4h3AL8b\nQTk0yQTSwJQTSAPzAbyL1AFxEann+no91pMLhdna+psStdOaMO1mE3Jokkb0EO8mn6MwAyRdQPoS\nmCbpfFJrorpclyZMu9mEHJpkH9LQ3q0e4rfQ20O8NbTHes0tCrPka6Q5GB7Oy+e0Ldetr2k3XwG8\ncITl0AQD6SG+XnOhMEtujYibgL9ExK/6WK5LX9Nu3k6adnNH6pl2swk5NMkPSLPLPURbD3FgL9Il\nxOs1FwqzZB9JvwRGV2LdOJndmnYT8rSbpENiHwZOiYgPjZAcmqZJPcRr50JhBkTEJcB+wAJJ381T\nwVb3nOsqGisi4m7gSdNukobW2GmE5NAkpR7iG9PbQ3y95ZPZZllEPAAcJultwHsiojpZT8enQc3u\nyLlUp95sHfqaRer4NhJyaIzcsW8mrOkhviIi1py3knQ3a5+7WO94CA8zMyvyoSczMytyoTAzsyIX\nCrMukNTXzHFmjeRzFGZDIOkI4Fjgf9oe2go4nDRvwu45dnWrT0bu5fz6kTb3sv1j8lVPZkN3RkTM\nqQYkndrXipKuAJ4BPAf4iaRJwKERcUOnkzQbLB96MqvfmcCtwJeAn3Q5F7N+uUVhNjSPAcdLOqwt\nPok07APAIcCDpE5Zf8uPbUpqWYyrJUuzIXChMBuCiJgNzF7X45JeTppX+dR8/wpgPKmH78akuZjN\nGs0ns80GKQ/D/THSiexnkmbHmwLsC/wZmEoaefYYoAc4GFgKfBT4KzCNNEzIldW5oM2axoXCbJBy\noRgVEXMkHZLDU4AbIuKnkk4izYL2YtIhp98CWwCvAo4Dzs2zxpk1mg89mQ3NhpLGkCb0eayPx59P\nOj+xBbAHae5pSFNnbifpBmBpRLyzhlzNBsUtCrNByi2Kk0jzFEwiXc00BXg78L+kQ0tPB15CmmP5\nnoi4Nj/3GaRzF25RWOO5UJh1kCSN0HmmbT3iQmFmZkXucGdmZkUuFGZmVuRCYWZmRS4UZmZW5EJh\nZmZFLhRmZlbkQmFmZkX/B/jbtLnnGoYtAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x144856c0b38>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "emaotai_0816.groupby('品牌').已售出量.sum().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "689949462.0"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "685110981.0"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "emaotai_0816.销售额.sum()\n",
    "emaotai_0808.销售额.sum()"
   ]
  }
 ],
 "metadata": {
  "hide_input": false,
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.0"
  },
  "toc": {
   "colors": {
    "hover_highlight": "#DAA520",
    "navigate_num": "#000000",
    "navigate_text": "#333333",
    "running_highlight": "#FF0000",
    "selected_highlight": "#FFD700",
    "sidebar_border": "#EEEEEE",
    "wrapper_background": "#FFFFFF"
   },
   "moveMenuLeft": true,
   "nav_menu": {
    "height": "12px",
    "width": "252px"
   },
   "navigate_menu": true,
   "number_sections": true,
   "sideBar": true,
   "threshold": 4,
   "toc_cell": false,
   "toc_section_display": "block",
   "toc_window_display": false,
   "widenNotebook": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
